SPREADSHEET MODELLING

Grading Criteria

Achieved
(Y/N)

Evidence
Page No

Assessor
Comments/Feedback

PASS grade criteria

P1

describe the uses of spreadsheet software

P2

explain why spreadsheets may need to be converted to alternative file formats

P3

develop a spreadsheet model to meet particular needs

P4

use simple formulae and functions to process information

P5

use data types and formatting to present information

P6

use appropriate tools to present data.

P7

test a spreadsheet to ensure that it is fit for purpose

P8

produce user documentation for a spreadsheet model

MERIT grade criteria

M1

refine a spreadsheet model by changing rules and values

M2

justify choice of tools for presenting data

M3

analyse and interpret data from a spreadsheet model

DISTINCTION grade criteria

D1

evaluate a spreadsheet model suggesting further refinements

D2

use automated features in the spreadsheet model.